| Address | nvarchar | 60 | NULL | Employees, Suppliers, Customers |
| BirthDate | datetime | 8 | NULL | Employees |
| CategoryID | int | 4 | NULL | Products, Categories |
| CategoryName | nvarchar | 15 | NOT NULL | Categories |
| City | nvarchar | 15 | NULL | Employees, Suppliers |
| City | nvarchar | 20 | NULL | Customers |
| CompanyName | nvarchar | 40 | NOT NULL | Customers, Suppliers, Shippers |
| ContactName | nvarchar | 30 | NULL | Suppliers, Customers |
| ContactTitle | nvarchar | 30 | NULL | Customers, Suppliers |
| Country | nvarchar | 15 | NULL | Employees, Suppliers, Customers |
| CustomerDesc | ntext | 16 | NULL | CustomerDemographics |
| CustomerID | nchar | 5 | NOT NULL | CustomerCustomerDemo, Customers, Orders |
| CustomerTypeID | nchar | 10 | NOT NULL | CustomerDemographics, CustomerCustomerDemo |
| Description | ntext | 16 | NULL | Categories |
| Discontinued | bit | 1 | NOT NULL | Products |
| Discount | real | 4 | NOT NULL | Order Details |
| EmployeeID | int | 4 | NOT NULL | Employees, EmployeeTerritories, Orders |
| Extension | nvarchar | 4 | NULL | Employees |
| Fax | nvarchar | 24 | NULL | Suppliers, Customers |
| FirstName | nvarchar | 10 | NOT NULL | Employees |
| Freight | money | 8 | NULL | Orders |
| HireDate | datetime | 8 | NULL | Employees |
| HomePage | ntext | 16 | NULL | Suppliers |
| HomePhone | nvarchar | 24 | NULL | Employees |
| LastName | nvarchar | 20 | NOT NULL | Employees |
| Notes | ntext | 16 | NULL | Employees |
| OrderDate | datetime | 8 | NULL | Orders |
| OrderID | int | 4 | NOT NULL | Orders, Order Details |
| Phone | nvarchar | 24 | NULL | Shippers, Suppliers, Customers |
| Photo | image | 16 | NULL | Employees |
| PhotoPath | nvarchar | 255 | NULL | Employees |
| Picture | image | 16 | NULL | Categories |
| PostalCode | nvarchar | 10 | NULL | Employees, Suppliers, Customers |
| ProductID | int | 4 | NOT NULL | Products, Order Details |
| ProductName | nvarchar | 40 | NOT NULL | Products |
| Quantity | smallint | 2 | NOT NULL | Order Details |
| QuantityPerUnit | nvarchar | 20 | NULL | Products |
| Region | nvarchar | 15 | NULL | Suppliers, Customers, Employees |
| RegionDescription | nchar | 50 | NOT NULL | Region |
| RegionID | int | 4 | NOT NULL | Region, Territories |
| ReorderLevel | smallint | 2 | NULL | Products |
| ReportsTo | int | 4 | NULL | Employees |
| RequiredDate | datetime | 8 | NULL | Orders |
| ShipAddress | nvarchar | 60 | NULL | Orders |
| ShipCity | nvarchar | 15 | NULL | Orders |
| ShipCountry | nvarchar | 15 | NULL | Orders |
| ShipName | nvarchar | 40 | NULL | Orders |
| ShippedDate | datetime | 8 | NULL | Orders |
| ShipperID | int | 4 | NOT NULL | Shippers |
| ShipPostalCode | nvarchar | 10 | NULL | Orders |
| ShipRegion | nvarchar | 15 | NULL | Orders |
| ShipVia | int | 4 | NULL | Orders |
| SupplierID | int | 4 | NOT NULL | Suppliers, Products |
| TerritoryDescription | nchar | 50 | NOT NULL | Territories |
| TerritoryID | nvarchar | 20 | NOT NULL | EmployeeTerritories, Territories |
| Title | nvarchar | 30 | NULL | Employees |
| TitleOfCourtesy | nvarchar | 25 | NULL | Employees |
| UnitPrice | money | 8 | NOT NULL | Order Details, Products |
| UnitsInStock | smallint | 2 | NULL | Products |
| UnitsOnOrder | smallint | 2 | NULL | Products |